{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Mileage","Travel Expenses","Data","Drop Downs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":44,"n_cols":1,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["IN-STATE TRAVEL LOG INSTRUCTIONS"]
[]
[" Mileage Expenses Tab: (Asterisk fields are mandatory)"]
["Add traveler's name and month/year of travel"]
["Add the complete accounting line in columns G-J  (not all accounts have a sub-account, sub-object and project code)"]
["Add a clear business purpose for each travel destination"]
["Click \"Calculate\" to auto sum expenses"]
["Make sure the sheet is in landscape and fits on one page. "]
["If you have additional expenses other than mileage, go to the Travel Expenses tab"]
[]
["Travel Expenses Tab:"]
["Use Expense Type drop down to add expenses to be claimed"]
["Add the complete accounting line in columns G-I (not all accounts have a sub-account, sub-object and project code)"]
["Add a clear business purpose for each travel destination"]
["  Meal Per Diems are at the bottom. Use the drop down \"X\" to identify which meals were provided or should be excluded (BR, LU, DI, M)"]
["Click \"Calculate\" to auto sum expenses"]
["If there are expenses on this sheet, this sheet must be included. Make sure the sheet is in landscape and fits on one page."]
[]
["Please Remember:"]
["1. MSU Travel Policy states that mileage is reimbursed from the main place of business unless driving from home is closer to the destination. Please provide explanation if home is closer. "]
["2. Submit in-state travel on a monthly basis."]
["3. Travel Expense Reports should be submitted within 30 days of the trip's end date."]
["4. Travelers have 90 days from the trip's end date to submit their Travel Expense Reports. After 90 days, out of pocket expenses are non-reimbursable. "]
[]
["Submission of Travel Log:"]
["If the MSUE Business Office will be processing your travel, please save in Excel and email all receipts including the agenda to MSUE.BusOffice@msu.edu, cc: receipts@concur.com."]
["If submitting expenses in Concur yourself, you must save as a pdf before attaching in Concur. All completed tabs including the total cost tab should be attached. "]
[]
["Business Purpose Examples:"]
["https://www.canr.msu.edu/od/uploads/files/Business_Office/Business_Purposes.pdf"]
[]
["Object Codes:"]
["https://www.canr.msu.edu/od/business_office/Object_Code_Quick_Ref_Guide.xlsx"]
[]
["The Travel Reimbursement Chart is located at: "]
["http://ctlr.msu.edu/COTravelNew/ReimbursementChart.aspx"]
[]
["Meal & Incidental Expense Rates are located at:"]
["http://ctlr.msu.edu/COTravelNew/MealAndIncidentalExpenseRates.aspx"]
[]
["Travel Policies Effective July 1, 2019"]
["http://ctlr.msu.edu/COMBP/mbp70ebs-July2019.aspx"]
[]
["If you have any questions about completing the travel log, please contact your fiscal officer or transactional assistant."]

{"sheet":"Mileage","index":1,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,0,5,7],[18,9,18,11],[0,9,0,14],[0,0,0,7],[3,0,3,2],[3,3,3,7],[1,0,1,1],[2,0,2,1],[1,2,1,7],[2,2,2,7],[18,0,18,8],[19,10,19,11],[20,10,20,11],[21,10,21,11],[22,10,22,11],[23,10,23,11],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[32,10,32,11],[33,10,33,11],[41,10,41,11],[19,12,19,16],[20,12,20,16],[21,12,21,16],[22,12,22,16],[23,12,23,16],[24,12,24,16],[25,12,25,16],[26,12,26,16],[27,12,27,16],[28,12,28,16],[34,10,34,11],[35,10,35,11],[36,10,36,11],[37,10,37,11],[38,10,38,11],[39,12,39,16],[40,12,40,16],[41,12,41,16],[16,9,16,13],[34,12,34,16],[35,12,35,16],[36,12,36,16],[37,12,37,16],[38,12,38,16],[29,12,29,16],[30,12,30,16],[31,12,31,16],[32,12,32,16],[33,12,33,16],[39,10,39,11],[40,10,40,11]]}
["IN-STATE TRAVEL LOG",null,null,null,null,null,null,null,null,"Accounting Line Totals"]
["Travelers Name:  ",null,null,null,null,null,null,null,null,"Account","Sub-Account","Object Code","Sub-Object Code","Project Code","Amount"]
["Month/Year:  ",null,null,null,null,null,null,null,null,null,null,6901,null,null,{"$f":"SUMIFS($F$21:$F$42,$G$21:$G$42,J3,$H$21:$H$42,IF(K3<>0,K3,\"\"),$I$21:$I$42,IF(M3<>0,M3,\"\"),$J$21:$J$42,IF(N3<>0,N3,\"\"))","v":0}]
["Primary Business Office Address:",null,null,null,null,null,null,null,null,null,null,6901,null,null,{"$f":"SUMIFS($F$21:$F$42,$G$21:$G$42,J4,$H$21:$H$42,IF(K4<>0,K4,\"\"),$I$21:$I$42,IF(M4<>0,M4,\"\"),$J$21:$J$42,IF(N4<>0,N4,\"\"))","v":0}]
["*Mileage is reimbursed from the main place of business to the destination unless driving from home is closer to the destination.",null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,6901,null,null,0]
[null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,null,{"$f":"SUM(O3:O16)","v":0}]
[]
["Asterisks indicate REQUIRED cells ",null,null,null,null,null,null,null,null,"USE DROP DOWN"]
["Date*","Starting City*","Destination City*","Mileage*","Mileage Rate","Amount","Account*","Sub-Account (if applicable)","Sub-Object Code (if applicable)","Project Code (if applicable)","Were MSU students part of this trip? If yes, add names to business purpose*",null,"Business Purpose* (If RC/RG account - A brief explanation of how the expense supports the scope of the project) *Add a note if leaving from home is closer to your destination."]
[null,null,null,null,0.625,{"$f":"D21*E21","v":0}]
[null,null,null,null,0.625,{"$f":"D22*E22","v":0}]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,{"$f":"D30*E30","v":0}]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,{"$f":"D37*E37","v":0}]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,null,null,0.625,0]
[null,null,"Mileage Total",{"$f":"SUM(D21:D42)","v":0}]
[null,null,"Transportation Sub-total",null,null,{"$f":"SUM(F21:F42)","v":0}]

{"sheet":"Travel Expenses","index":2,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,1,24,3],[25,1,25,3],[25,9,25,14],[0,5,0,8],[15,5,15,7],[17,0,17,7],[1,0,6,4],[18,9,18,14],[18,1,18,3],[24,9,24,14],[20,9,20,14],[21,9,21,14],[23,1,23,3],[22,9,22,14],[20,1,20,3],[21,1,21,3],[22,1,22,3],[19,9,19,14],[23,9,23,14],[19,1,19,3],[26,9,26,14],[27,9,27,14],[33,16,33,17],[32,0,32,6],[30,1,30,3],[31,1,31,3],[32,7,32,9],[28,9,28,14],[29,9,29,14],[28,1,28,3],[29,1,29,3],[30,9,30,14],[31,9,31,14],[26,1,26,3],[27,1,27,3]]}
[null,null,null,null,null,"Accounting Line Totals"]
["Other travel Expenses and meal per diems",null,null,null,null,"Account","Sub-Account","Project Code","Amount"]
[null,null,null,null,null,null,null,null,{"$f":"SUMIFS($E$20:$E$32,$G$20:$G$32,F3,$H$20:$H$32,IF(G3<>0,G3,\"\"),$I$20:$I$32,IF(H3<>0,H3,\"\"))","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,"TOTAL",null,null,{"$f":"SUM(I3:I15)","v":0}]
[]
["OTHER TRAVEL EXPENSES (Asterisks indicate REQUIRED cells) ",null,null,null,null,null,null,null,"USE DROP DOWN"]
["Date*","Expense Type (Click drop down)*",null,null,"Amount*","City (Location)*","Account*","Sub Account (if applicable)","Project Code","Business Purpose (If RC/RG account - A brief explanation of how the expense supports the scope of the project) *"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Per diem explanation\nExcluding all day per diem: If excluding all per diems for travel date, indicate this by using the drop down X\nMeals & IE provided: Use drop down X ",null,null,null,null,null,null,"If cell has an asterisk it is required information",null,null,"USE DROP DOWN"]
["Date*","Exclude all per diems this date","Breakfast","Lunch","Dinner","$5 Daily allowance","City of meal (location)","Per diem amount ONLY if claiming less than per diem(EX. BR$4, LU $3, DI $2)","Account*","Sub-Account (if applicable)","Project Code"]

{"sheet":"Data","index":3,"n_rows":86,"n_cols":1,"rows_kept":86,"cut":false,"hidden":true,"merged":[]}
["Project Code DropDown Data"]
["MSUEALCONA"]
["MSUEALGER"]
["MSUEALLEGA"]
["MSUEALPENA"]
["MSUEANTRIM"]
["MSUEARENAC"]
["MSUEBARAGA"]
["MSUEBARRY"]
["MSUEBAY"]
["MSUEBENZIE"]
["MSUEBERRIE"]
["MSUEBRANCH"]
["MSUECALHOU"]
["MSUECAMPUS"]
["MSUECASS"]
["MSUECHARLE"]
["MSUECHEBOY"]
["MSUECHIPPE"]
["MSUECLARE"]
["MSUECLINTO"]
["MSUECRAWFO"]
["MSUEDELTA"]
["MSUEDICKIN"]
["MSUEEATON"]
["MSUEEMMET"]
["MSUEFLINT"]
["MSUEGENESE"]
["MSUEGLADWI"]
["MSUEGOGEBI"]
["MSUEGRANDT"]
["MSUEGRATIO"]
["MSUEHILLSD"]
["MSUEHOUGHT"]
["MSUEHURON"]
["MSUEINGHAM"]
["MSUEIONIA"]
["MSUEIOSCO"]
["MSUEIRON"]
["MSUEISABEL"]
["MSUEJACKSO"]
["MSUEKALAMA"]
["MSUEKALKAS"]
["MSUEKENT"]
["MSUEKEWEEN"]
["MSUELAKE"]
["MSUELAPEER"]
["MSUELEELAN"]
["MSUELENAWE"]
["MSUELIVING"]
["MSUELUCE"]
["MSUEMACKIN"]
["MSUEMACOMB"]
["MSUEMANIST"]
["MSUEMARQUE"]
["MSUEMASON"]
["MSUEMECOST"]
["MSUEMENOMI"]
["MSUEMIDLAN"]
["MSUEMISSAU"]
["MSUEMONROE"]
["MSUEMONTCA"]
["MSUEMONTMO"]
["MSUEMUSKEG"]
["MSUENEWAYG"]
["MSUEOAKLAN"]
["MSUEOCEANA"]
["MSUEOGEMAW"]
["MSUEONTONA"]
["MSUEOSCEOL"]
["MSUEOSCODA"]
["MSUEOTSEGO"]
["MSUEOTTAWA"]
["MSUEPRESQU"]
["MSUEROSCOM"]
["MSUESAGINA"]
["MSUESANILA"]
["MSUESCHOOL"]
["MSUESHIAWA"]
["MSUESTCLAI"]
["MSUESTJOSE"]
["MSUETUSCOL"]
["MSUEVANBUR"]
["MSUEWASHTE"]
["MSUEWAYNE"]
["MSUEWEXFOR"]

{"sheet":"Drop Downs","index":4,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
["Bus"]
["Business Meetings - Food & Beverage"]
["Car Rental"]
["Car Rental Fuel"]
["Conference Registration Fees"]
["Lodging"]
["Office Expenses"]
["Parking"]
["Taxi-Rideshare"]
["Tolls"]
["Train"]
["Other - explain in Business Purpose Line"]